package api.workerswithdb;

import java.util.ArrayList;
import java.util.Date;

public interface IDAOWorker {
	public ArrayList<String> getEmptyGarage();

	public ArrayList<String> getOrdersByMaster(String masterName);

	public ArrayList<String> getMastersByOrder(Integer numberOrder);

	public ArrayList<String> getEmptyPlacesOnDate(Date date);

	public ArrayList<String> getNextFreeDate();

	public ArrayList<String> SortOrderByBeginningDate();

	public ArrayList<String> SortOrderByDeadlineDate();

	public ArrayList<String> SortOrderByFillingDate();

	public ArrayList<String> SortOrderByPrice();

	public ArrayList<String> SortMasterByEmployment();

	public ArrayList<String> SortMasterByName();

	public ArrayList<String> SortMadingOrderByBeginningDate();

	public ArrayList<String> SortMadingOrderByDeadlineDate();

	public ArrayList<String> SortMadingOrderByFillinggDate();

	public ArrayList<String> SortMadingOrderByPrice();

	public ArrayList<String> SortDeletedOrderByPeriodByBeginningDate(
			Date begin, Date end);

	public ArrayList<String> SortCanceledOrderByPeriodByBeginningDate(
			Date begin, Date end);

	public ArrayList<String> SortMadeOrderByPeriodByBeginningDate(Date begin,
			Date end);

	public ArrayList<String> SortDeletedOrderByPeriodByDeadlineDate(Date begin,
			Date end);

	public ArrayList<String> SortCanceledOrderByPeriodByDeadlineDate(
			Date begin, Date end);

	public ArrayList<String> SortMadeOrderByPeriodByDeadlineDate(Date begin,
			Date end);

	public ArrayList<String> SortDeletedOrderByPeriodByFillingDate(Date begin,
			Date end);

	public ArrayList<String> SortCanceledOrderByPeriodByFillingDate(Date begin,
			Date end);

	public ArrayList<String> SortMadeOrderByPeriodByFillingDate(Date begin,
			Date end);

	public ArrayList<String> SortDeletedOrderByPeriodByPrice(Date begin,
			Date end);

	public ArrayList<String> SortCanceledOrderByPeriodByPrice(Date begin,
			Date end);

	public ArrayList<String> SortMadeOrderByPeriodByPrice(Date begin, Date end);

	public ArrayList<String> addMaster(String masterName);

	public ArrayList<String> deleteMaster(String masterName);

	public ArrayList<String> addGarage(Integer garageNumber);

	public ArrayList<String> deleteGarage(Integer numberGarage);

	public ArrayList<String> addOrder(Integer orderNumber, Date fillingDate,
			Date deadlineDate, Date beginingDate, Integer price,
			String masterName, Integer numberGarage);

	public ArrayList<String> markOrderDeleted(Integer numberOrder);

	public ArrayList<String> markOrderCanceled(Integer numberOrder);

	public ArrayList<String> markOrderMade(Integer numberOrder);

	public ArrayList<String> ShiftTimeOrder(Date newDate, Integer numberOrder);

	public ArrayList<String> cloneOrder(Integer numberOrder);

	public ArrayList<String> exportGarages(Integer number_garage);

	public ArrayList<String> exportMasters(String master_name);

	public ArrayList<String> exportOrders(Integer order_number);

	public ArrayList<String> importGarages();

	public ArrayList<String> importMasters();

	public ArrayList<String> importOrders();

}
